Problem Note 44296: Expanding a SAS® Financial Management table that contains large nested dimensions on the rows might result in a system time-out exception
 |  |  |  |  |
If you expand a dimension on a SAS Financial Management Read-Only (OLAP) table that contains multiple large nested dimensions, you might encounter red cells in the table. You might also find an error similar to the following is written to the AMO log:
error retrieving protection map
System.Net.WebException: The operation has timed out
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
request)
at
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest
request)
at Com.Sas.Ses.OfficeIntegration.Model.SOAPService.GetWebResponse(WebRequest
request) in C:\Users\<user ID>\Documents\Visual Studio
2005\Projects\FM52\Model\SOAPService.cs:line 69
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Com.Sas.Ses.OfficeIntegration.Model.FMExcelService.FMExcelService.getCellMetadat
a(Int32 in0, DataProtectionQuery in1,
SliceDescriptor in2, SecurityContext in3) in C:\Users\<user ID>\Documents\Visual Studio 2005\Projects\FM52\Model\FMExcelService.cs:line 2964 at Com.Sas.Ses.OfficeIntegration.View.Table.getProtectionMap(Int32 frows, Int32 fcolumns) in C:\Users\<user ID>\Documents\Visual Studio 2005\Projects\FM52\View\Table.cs:line 7773
This is a client-side error, and the server logs do not reveal this error.
SliceDescriptor in2, SecurityContext in3) in C:\Users\<user ID>\Documents\Visual Studio 2005\Projects\FM52\Model\FMExcelService.cs:line 2964 at Com.Sas.Ses.OfficeIntegration.View.Table.getProtectionMap(Int32 frows, Int32 fcolumns) in C:\Users\<user ID>\Documents\Visual Studio 2005\Projects\FM52\View\Table.cs:line 7773
This is marked as fixed in SAS Financial Management 5.3.
For information about enabling the AMO log, please refer to SAS Note 19846.
For default SAS Financial Management log locations, please refer to SAS Note 20058.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
A fix for this issue for SAS Financial Management 5.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D73.html#44296| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-09-27 08:34:09 |
| Date Created: | 2011-09-14 15:11:35 |